package cn.kys.modules.system.repository;


import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;


public interface StatisticsRepository {
    public List fieldvalueDictionary(@Param("layerName")  String layerName );
    public Map getLandType(String condition, String type);

    public List chinesefielddictionary(@Param("layerName")  String layerName );
    public Map getContractAmountMoney(String year, String month);

    public List getCitysContractStatistics(String city);

    public List getAllCities();

    //已过期
    public String getContractPassed();

    //欲过期
    public String getContractNearPassed();

    //已签约
    public String getContractVisaed();

    //待签约
    public String getContractWaitVisa();

    //总数
    public String getTotalContract();

    public List getCropsStatistics(String crops);

    public List getAllCrops();

    //两年期合同数(当年)
    public String getTwoTotalContract();

    //一年期合同数(当年)
    public String getOneTotalContract();
    //两年期合同数(去年)
    public String getTwoTotalContractLastYear();
    //一年期合同数(去年)
    public String getOneTotalContractLastYear();



    public List findKSDQ();

    //查询权属名称
    public List findQSDW(@Param("qsdw_name") String qsdw_name);

    public List findAllQSDWByCode(@Param("qsdw_code") String qsdw_code);

    public List findAllQSDWByCodeKSDQ(@Param("qsdw_code") String qsdw_code);

    public Map findSingleQSDWExtentByCode(@Param("qsdw_code") String qsdw_code);


    public List findSingleQSDWByCode(@Param("qsdw_code") String qsdw_code);

    public List findTownshipByCode(String qsdw_code);

    public List findVillageByCode(String qsdw_code);

    public Map findSDArea(@Param("qsdw_code_Num") int qsdw_code_Num, @Param("qsdw_code") String qsdw_code,@Param("qsxz") String qsxz,@Param("dlbmNum") int dlbmNum,@Param("dlbm") String dlbm);


    public Map findSDAreaKSDQ(@Param("qsxz") String qsxz,@Param("dlbmNum") int dlbmNum,@Param("dlbm") String dlbm);

    public List findSDByPos(@Param("qsdw_code_Num") int qsdw_code_Num, @Param("qsdw_code") String qsdw_code,@Param("lon") String lon, @Param("lat") String lat);

    public Map findKSDQArea(@Param("qsdw_code") String qsdw_code);

    public Map findKSDQPopulation(@Param("qsdw_code") String qsdw_code);


    //农经权-集体土地面积
    public Map findJTTDArea(@Param("qsdw_code") String qsdw_code);

    public List findQSDWByCode(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length);

    public List findQSDWByCodePage(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length, @Param("pageSize") int pageSize, @Param("offset") int offset);

    public String findQSDWByCodeCount(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length);
    public String findNjqTdqlMaodunCount(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length);


    public String findNjqTdqlMaodunArea(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length);


    public String findNjqGytdMaodunCount(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length);


    public String findNjqGytdMaodunArea(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length);

    public List findGeoByPosNjq_gytd_maodun(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length,@Param("lat") String lat,@Param("lon") String lon);

    public List findGeoByPosNjq_tdql_maodun(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length,@Param("lat") String lat,@Param("lon") String lon);

    public List findSDGeoByPos(@Param("cut_num") int cut_num,@Param("qsdw_code") String qsdw_code,@Param("length") int length,@Param("lat") String lat,@Param("lon") String lon);

    public List searchZHZSList();

    public String searchZHZSListByCondition(@Param("sqlStr") String sqlStr);

    public List searchSql(@Param("sqlStr") String sqlStr);

    public List fieldvalue_dictionary(@Param("layerName")  String layerName );

    public Map getCenter(@Param("qsdw_code") String qsdw_code);

}


